2013-11-26 - 9760.100 - Spec - BPC Management source #FinanceControlling

SPECIFICATIONS

9760.100 - BPC Management source


Requirement Summary


Need to create a source in BW for management reports combining COPA and BPC plan sources.

Admin Info


Purpose
Create a source in BW for management reports combining COPA and BPC plan.
Requested By
Jack Mehltretter
Spec Created By
Uday Kumar P
Spec Created Date
11/26/2013
Spec QA by
Uday Kumar P
Objects
BPC Cube(ZBPC_PLAN)
BPC MultiProvider(ZBPC_MP)
Document Status
Complete

References


Prior Tickets

None

Documents

Attached with the related release note.

Functional Requirement


1. Need to create a new infocube for BPC Management source with required Characteristics, Key figures and Navigational Attributes to meet the NEC requirements.
2. Need to create a new Multiprovider to meet the requirement of BPC Management source which combines BPC Plan infocube with COPA, Open Orders, Order Condition and Contract order infocubes.
3. Need to create transport request in BPD(BW7.3 Development) and collect the infocube, Multiprovider and their respective data flows.

Solution Summary


1. Need to create a new infocube with required Characteristics, Key Figures and Navigational attributes.
2. Need to create transformation between the source and infocube.
3. Need to create Data Transfer Process between source and infocube.
4. Need to create a new Multiprovider to combine BPC Plan infocube with COPA, Open Orders, Order Condition and Contract order infocubes.
5. Need to assign the characteristics in Multiprovider from respective infoproviders to meet the reporting requirements.
6. Need to collect the infocube, Multiprovider & their dataflows into respective transport requests.
7. Need to test and transport it to BPQ(BW 7.3 Quality) for further testing.

Test Plan

SNo
Test Scenario
Expected Results
1
Check if the data is correctly loaded into infocube.
Data should be validated correctly with the source data.
2
Check the new source against NEC Standard Infoprovider Checklist.
Source should be successfully validated as per checklist.
3
Check if all the objects are collected into the transport request.
All the objects should be collected into the transport request.

Solution Details


1. Need to create a new infocube(ZBPC_PLAN) with required Characteristics, Key Figures and Navigational attributes.
2. Need to create the transformation between the source(/CPMB/OBIU3SI) and the BPC infocube(ZBPC_PLAN).
3. Need to create Data Transfer Process(DTP) between source(/CPMB/OBIU3SI) and BPC infocube(ZBPC_PLAN).
4. Need to create a new Multiprovider(ZBPC_MP) to meet the requirement of BPC Management source where we need to combine BPC Plan infocube with COPA(ZCOPA_C03), Open Orders(ZSDC_OPN), Order Condition(ZSD_C15) and Contract order(ZSD_CONTR).
5. Need to assign the characteristics in Multiprovider from respective infoproviders to meet the NEC requirements.
6. Need to collect the infocube, Multiprovider & their data flows into respective transports requests.
7. Need to check whether all the objects are collected into transport requests, unit test and then transport it to BPQ(BW 7.3 Quality).

Issues


None